SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweAfiliaciones
AS
SELECT     idAfiliacion AS ID, idAgente, TipoAfiliacion, NumeroAfiliado, Organismo, MontoMensual, FechaInicioAportes
FROM         dbo.tb_Afiliaciones


GO
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [PersonalDocente]
GRANT INSERT ON  [dbo].[vweAfiliaciones] TO [PersonalDocente]
GRANT DELETE ON  [dbo].[vweAfiliaciones] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweAfiliaciones] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [SoloVer]
GRANT SELECT ON  [dbo].[vweAfiliaciones] TO [Subsidios]
GO
